Skip Headers

Oracle® OLAP Application Developer's Guide 10g Release 2 (10.2) Part Number B14349-02 |
Home | Book List | Contents | Master Index | Feedback

Previous
| View PDF

# Index

A B C D E F G H I J L M N O P Q R S T U V W X

## A

  access rights, 6.3.3
  active catalogs, 5.2.1
  ALL_ATTRIBUTES dimension, A.7.1.6
  ALL_ATTRTYPES dimension, A.7.2.2
  ALL_CUBES dimension, A.7.1.1
  ALL_DESCRIPTIONS variable, A.8.1
  ALL_DESCTYPES dimension, A.7.2.1
  ALL_DIMENSIONS dimension, A.7.1.3
  ALL_HIERARCHIES dimension, A.7.1.4
  ALL_LANGUAGES dimension, A.7.2.3
  ALL_LEVELS dimension, A.7.1.5
  ALL_MEASURES dimension, A.7.1.2
  ALL_OBJECTS dimension, A.7.1.7
  allocation, B.3
  ALTER SESSION commands, 6.5
  analysis tools
    described, 1.4
  analytic capabilities
    compared, 1.7.4
  Analytic Workspace Java API, 5.5, 7.1.3
  Analytic Workspace Manager, 3
  analytic workspaces
    basic process overview, 1.9
    basic steps for creating, 3.4.2
    best practices, 1.7.1, 1.7.1
    database storage, 6.7.1
    defined, 1.6, 1.6, 1.8.2
    standard form, 3.4
  applications
    differences from Express, B.2.1
  ATTRDEF object, A.6.3.7
  attributes
    See Also dimension attributes
    See Also level attributes
    creating logical, 7.3.2.3, 7.5.1
    logical, 1.5.5
  authentication, 6.3
  AW$ tables, 6.7.2
  AW$CLASS property, A.5.1
  AW$CREATEDBY property, A.5.1
  AW$LASTMODIFIED property, A.5.1
  AW$STATE property, A.5.1
  AW_NAMES variable, A.7.4.1
  AWXML package, 5.5, 7.1.3

## B

  BFILE security, 6.6
  BI Beans
    described, 5.1.2, 5.2
    relational data source, 5.4
    relational data sources, 5.4
    See also OLAP API

## C

  caches
    use in iterative queries, 5.3.3
  calculation engine
    defined, 1.8.1
  catalogs class
    database standard form, A.7
  character sets, B.1.4
  CHARSET option, B.1.4
  classes
    database standard form, A.3.2
  COMMIT command, B.3.3
  configuration procedures, 6.1
  conjoints, B.3.2
  CONNECT role, 6.3.3
  connect string
    for Analytic Workspace Manager, 3.2.4
  CREATE_DB_STDFORM program, B.4.1
  crosstab bean, 5.2.5
  CUBE_MEASURES valueset, A.7.3.1
  CUBEDEF dimension, A.6.1.1
  cubes, 1.6
    defined, 7.3.3
  cursors, 5.3.3
  custom measures
    BI Beans support, 5.2.7
  CWM2
    write APIs, 7.5.1
  CWM2_OLAP_CATALOG package, 7.5.5
  CWM2_OLAP_CUBE package, 7.5.2
  CWM2_OLAP_DIMENSION package, 7.5.1
  CWM2_OLAP_HIERARCHY package, 7.5.1
  CWM2_OLAP_LEVEL package, 7.5.1
  CWM2_OLAP_LEVEL_ATTRIBUTE package, 7.5.1
  CWM2_OLAP_MEASURE package, 7.5.2
  CWM2_OLAP_PC_TRANSFORM package, 7.5.4
  CWM2_OLAP_VALIDATE package, 7.5.5

## D

  data formatting, 5.2.3
  data models, 1.5
  data stores
    described, 1.7
  data striping, 6.2
  database configuration, 6.1
  database security, 6.3
  database standard form
    described, A.1
    specification, A
  DEFAULT_HIER relation, A.8.2
  demand planning systems, 1.3
  DIM_ATTRIBUTES relation, A.7.3.4
  DIM_HIERARCHIES relation, A.7.3.2
  DIM_LEVELS relation, A.7.3.3
  DIM_LEVELS valueset, A.7.3.4
  DIMDEF dimension, A.6.3.1
  dimension hierarchies
    See hierarchies
  dimension order
    basic rules, 3.7.2
  dimension tables
    defining metadata, 7.3.2.1
  dimensions
    creating logical, 7.3.2.3
    logical, 1.5.3, 7.3.2.1
    time, 7.3.2.2
  directories
    database, 6.6
  directory object, 8.5.1
  drilling, 5.2.2
  dynamic performance tables, 6.8

## E

  EDDE.HIERMNT program (obsolete), B.4.4
  EDDE.MSG program (obsolete), B.4.4
  EIF files, B.4
  Excel add-in, 1.4
  Express Connection Utility (obsolete), B.2.1
  Express databases
    converting to standard form, B.4
  Express Relational Access Administrator (obsolete), B.1.3
  Express Relational Access Manager (obsolete), B.1.3
  EXTCALL (obsolete), B.3.2
  extensions class
    database standard form, A.9

## F

  fact tables
    defining metadata, 7.3.3
  features class
    database standard form, A.8
  files
    allowing access, 6.6
  financial applications, 1.3
  forecasting commands
    OLAP DML, 4.1
  formatting
    data, 5.2.3

## G

  Global Computing Company
    data requirements, 2.1.1
  Global star schema, 2.4
  GLOBAL_AW user
    defining, 3.13.1
  globalization, B.1.4
  Globalization Technology See NLS
  graph bean, 5.2.4

## H

  HIER_LEVELS valueset, A.6.3.6
  hierarchies
    creating logical, 7.3.2.3
    logical, 1.5.4
  HIERLIST dimension, A.6.3.2

## I

  IDE
    defined, 5.1.3
  implementation class
    database standard form, A.6
  initialization parameters, 6.5
  init.ora file, 6.4, 6.4

## J

  Java
    described, 5.1
    sandbox security, 5.1.1
  Java APIs for OLAP, 5
  JDeveloper, 5.1.3
  JOB_QUEUE_PROCESSES parameter, 6.4

## L

  language support, B.1.4
  LEVELLIST dimension, A.6.3.3
  LEVELREL relation, A.6.3.4
  levels
    creating logical, 7.3.2.3
    logical, 1.5.4
  localization, B.1.4
  login names, 6.3

## M

  materialized views
    CWM2, 8.5, 8.5.1, 8.5.2
    grouping sets, 8.5
  MDI
    defined, 5.1.3
  MEASUREDEF object, A.6.2.1
  measures
    custom, 5.2.7
    logical, 1.5.2
  MEMBER_CREATEDBY variable, A.8.5
  MEMBER_FAMILYREL relation, A.8.6
  MEMBER_INHIER variable, A.8.4
  modeling support, B.3
  MOLAP
    analytic operations, 1.7.4
    defined, 1.7
  multibyte character sets
    Express equivalents, B.1.4
  multidimensional data, 1.6

## N

  naming conventions
    database standard form, A.4
  NLS_LANG configuration parameter, B.1.4
  n-pass functions, 5.3.2
  number formatting, 5.2.3

## O

  object-oriented programming, 5.3
  ODBC (obsolete), B.3.2
  ODBC support (obsolete), B.1.3
  oescmd program (obsolete), B.1.1
  oesmgr program (obsolete), B.1.1
  OLAP
    defined, 1.2
  OLAP API
    described, 1.8.8, 5.1.2, 5.3
    relational data source, 5.4
    See also BI Beans
  OLAP Beans, 5.2, 5.2.6
  OLAP Catalog
    described, 1.8
    metadata model tables, 7.2.1
    read APIs, 7.2.1
    write APIs, 7.2.1
  OLAP DML
    described, 1.8.6
  OLAP Instance Manager (obsolete), B.1.1, B.1.1
  OLAP Management tool, 7.3
  OLAP metadata
    creating in Enterprise Manager, 7.3
    creating with CWM2 APIs, 7.5
    materialized views, 8.2.2
    steps for creating, 7.2.2
  OLAP Worksheet
    described, 3.1.3
    session sharing, 3.1
  OLTP
    defined, 1.2
  operating system commands (obsolete in OLAP DML), B.3.2
  optimization techniques, 6.2

## P

  paging, 5.2.2
  parameter file, 6.4
  parent-child relations
    described, 1.5.4
  PARENTREL relation, A.6.3.5
  partitioning, 6.7.1
  performance counters, 6.8
  Personal Express (obsolete), B.2.1
  pfile settings, 6.4
  PGA_AGGREGATE_TARGET parameter, 6.4
  PGA_TARGET parameter, 6.4
  pivoting, 5.2.2
  predictive analysis applications, 1.3
  Presentation Beans, 5.2
  PS$ tables, 6.7.2

## Q

  query builder, 5.2.7
  QUERY REWRITE system privilege, 6.3.3
  query tools
    described, 1.4

## R

  random sparsity, definition, 3.7.1.1
  regressions
    OLAP DML, 4.1
  Relational Access Administrator (obsolete), B.1.3
  Relational Access Manager (obsolete), B.1.3
  relational data sources, 5.4, 5.4, 8
  relational schema
    best practices, 1.7.2
  result sets, 5.3.3
  ROLAP
    analytic operations, 1.7.4
    defined, 1.7
  roles, 6.3.3
  ROLLUP command, B.3.2, B.4.1.1

## S

  schemas
    star, snowflake, 7.3, 8.2
  SELECT privilege, 6.3.3
  server parameter file, 6.4
  session sharing, B.2.2
  SESSIONS parameter, 6.4
  SNAPI (obsolete), B.3.2
  SNAPI communications (obsolete), B.2.2
  sparsity characteristics, 3.13.2
  sparsity pattern, definition, 3.7.1.1
  Spreadsheet Add-In
    described, 1.4
  SQL analytic operations, 1.7.4
  SQL command (OLAP DML), B.1.3
  SQL interface, 1.8.5
  standard form
    see database standard form
  startup parameters
    database, 3.14.2
  stoplight formatting, 5.2.3
  striping, 6.2
  summary data
    creating, 1.6.2
  summary data methods
    compared, 1.7.5
  system properties
    database standard form, A.5.1

## T

  tablespaces
    defining, 3.14.3
    for analytic workspaces, 6.2
  Time attributes
    creating for converted Express databases, B.4.3
  time dimensions, 7.3.2.2
  translation tables, B.1.4

## U

  UNDO_MANAGEMENT parameter, 6.4
  UNDO_TABLESPACE parameter, 6.4
  Unicode, B.1.4
  UPDATE command, B.3.3
  user access rights, 6.3.3
  user names, 6.3
  UTL_FILE_DIR parameter, 6.4, 8.5.1

## V

  VISIBLE variable, A.8.3

## W

  wizards
    BI Beans, 5.2.7

## X

  XCA (obsolete), B.3.2
  XML metadata, 5.5, 7.1.3
  XPDDDATA database (obsolete), B.4.4